Predicates

You can use THIS variable to iterate through object elements, filter objects by type, filter object fields against a specified condition.

Using THIS for filtering

#select just size that meets the condition
SELECT  order.info.size [this > 500] FROM orders

#select just LimitOrder types or Orders
SELECT order[this is deltix.orders.LimitOrder].info.* FROM orders

#select correlationId where source is LO_SOURCE, otherwise return NULL
SELECT order.id[source == 'LO_SOURCE'].correlationId FROM orders